CREATE TABLE [dbo].[SAP_Knowledge]
(
[ID] [numeric] (18, 0) NOT NULL IDENTITY(1, 1),
[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Detail] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAP_Knowledge] ADD CONSTRAINT [UQ__SAP_Know__2CB664DC2E1BDC42] UNIQUE NONCLUSTERED  ([Title]) ON [PRIMARY]

GO
ALTER TABLE [dbo].[SAP_Knowledge] ADD CONSTRAINT [PK_SAP_Knowledge] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
CREATE FULLTEXT INDEX ON [dbo].[SAP_Knowledge] KEY INDEX [PK_SAP_Knowledge] ON [full_text_title]
GO
ALTER FULLTEXT INDEX ON [dbo].[SAP_Knowledge] ADD ([Title] LANGUAGE 1033)
GO
